Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
EventID (FK)(PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | |
InternalRecallID | A number, code, or other value that identifies a specific recall event. This is the internal (to the retailer) identifier. | ID_RCL_INTRN | Identity | integer | |
ExternalRecallID | A number, code, or other value that identifies a specific recall event. This is the external (to the retailer) identifier. | ID_RCL_EXTRN | Identity | integer | |
IssuedByPartyID (FK) | A unique, system assigned identity for the Party that issued the RecallEvent | ID_PRTY | Identity | integer | Party(PA_PRTY) |
Instruction | Free text of instructions for the Worker's that are assigned to perform this Event. | DE_INSTR | DescriptionNarrative | varchar(4000) | |